Courtney S.
Courtney S.
Reactions
-
Re: Stop Calculating Days After a Cell Changes
To make it easier try breaking your IF function into the 3 separate parts/functions it should have, to write those out logically, and then combine into the final formula by putting commas between the…1 · -
Re: How do I get two automations and a cell formula to execute in the right sequence?
To make sure the second automation runs as the third step, use step two, the changing of the Due Date field, as the trigger for the second automation.1 · -
Re: Formula Help
Hello! Since the numbers are always the very first character in the answers, what if you did something like this instead for your helper columns, which is much shorter and also makes sure the result …1 · -
Re: Formula for 24hour clock overlap - booking clashes at the same time on the same day
Smartsheet doesn't have a way to make a booking system that prevents overlaps automatically, but there is some advice you may find helpful in these posts: Booking System in Smartsheets Forms — Smarts…1 · -
Re: How can I display data horizontally from data in a row format
In your first sheet, I think you'll need to add a column labelling the week # column that you want each row reported in. Then you can use the INDEX/COLLECT formula mentioned here: Formula combination…1 ·
